[dbo].[ScheduledTaskHistory]

Property	Value
Created	10:31:38 AM Tuesday, March 02, 2010
Last Modified	11:40:07 AM Monday, February 20, 2012

Property

Value

Created

10:31:38 AM Tuesday, March 02, 2010

Last Modified

11:40:07 AM Monday, February 20, 2012

Name	Data Type	Max Length (Bytes)
ScheduledTaskHistoryKey	uniqueidentifier	16
ScheduledTaskKey	uniqueidentifier	16
StartedOn	datetime	8
FinishedOn	datetime	8
CompletionStatus	nvarchar(20)	40
WorkflowInstanceKey	uniqueidentifier	16
LogText	ntext	max
MarkedForDeleteOn	datetime	8

Name

Data Type

Max Length (Bytes)

Allow Nulls

ScheduledTaskHistoryKey

uniqueidentifier

ScheduledTaskKey

uniqueidentifier

StartedOn

datetime

FinishedOn

datetime

CompletionStatus

nvarchar(20)

WorkflowInstanceKey

uniqueidentifier

LogText

ntext

max

MarkedForDeleteOn

datetime

	Name	Columns	Unique
	PK_ScheduledTaskHistory	ScheduledTaskHistoryKey
	IX_ScheduledTaskHistory_ScheduledTaskKey	ScheduledTaskKey

Name

Columns

Unique

PK_ScheduledTaskHistory

ScheduledTaskHistoryKey

IX_ScheduledTaskHistory_ScheduledTaskKey

ScheduledTaskKey

Name	Columns
FK_ScheduledTaskHistory_ScheduledTask	ScheduledTaskKey->[dbo].[ScheduledTask].[ScheduledTaskKey]

Name

Columns

FK_ScheduledTaskHistory_ScheduledTask

ScheduledTaskKey->[dbo].[ScheduledTask].[ScheduledTaskKey]

SQL Script

CREATE TABLE [dbo].[ScheduledTaskHistory]
(
[ScheduledTaskHistoryKey] [uniqueidentifier] NOT NULL,
[ScheduledTaskKey] [uniqueidentifier] NOT NULL,
[StartedOn] [datetime] NOT NULL,
[FinishedOn] [datetime] NULL,
[CompletionStatus] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[WorkflowInstanceKey] [uniqueidentifier] NULL,
[LogText] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MarkedForDeleteOn] [datetime] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
ALTER TABLE [dbo].[ScheduledTaskHistory] ADD CONSTRAINT [PK_ScheduledTaskHistory] PRIMARY KEY CLUSTERED ([ScheduledTaskHistoryKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_ScheduledTaskHistory_ScheduledTaskKey] ON [dbo].[ScheduledTaskHistory] ([ScheduledTaskKey]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ScheduledTaskHistory] ADD CONSTRAINT [FK_ScheduledTaskHistory_ScheduledTask] FOREIGN KEY ([ScheduledTaskKey]) REFERENCES [dbo].[ScheduledTask] ([ScheduledTaskKey])
GO